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?
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
