98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » V Loop Up
V Loop Up
Resolved · High Priority · Version 2003
Thu 9 Jul 2009, 16:32Delegate Alex said...
Alex has attended:
Excel Advanced course
V Loop Up
I have two spreadsheets of differing info - but there is a correlating column across the two which could be customer accout number for example. I want to bring back into one of the spreadsheets an item of data which is only contaiend within the 2nd spreadsheet - such as profit%. How do I do this?
Fri 10 Jul 2009, 09:57Trainer Simon said...
RE: V Loop Up
Hi Alex,
Thank you for your question.
Please find the formula below that we discussed yesterday:
=IF(B4="",VLOOKUP(A4,'C:\Users\Simon\AppData\Local\Microsoft\Windows\Temporary Internet Files\OLKE4F3\[Tel. No complete.xls]Sheet1'!$A$1:$B$6,2,FALSE),B4)
Si if B4 is blank, then lookup the value in A4 and search for it in the other spreadsheet and return the value in the 2nd column. If it isn't blank just use the value in B4.
I hope this answers your question.
Regards
Simon
Thu 16 Jul 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:##### displaying in ExcelWhen you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake. |
