Hiya,
I am trying to build a spreadsheet that will return some specific values across 2 worksheets.
In worksheet one i have;
sales partner name number deals application id amy 15 1089308
and in worksheet 2 i have;
n/a n/a application id n/a n/a 1089505
both worksheets have around 1000 rows of data (not in order!) in and i cannot manipulate the columns to use a standard vlookup.
What i would like to do is;
- in worksheet 2 I want to look up the application id on that line (i.e C1, C2 etc) on worksheet 1 (could be c600/c58/c7 etc) and return the name of the sales partner that did it.
i have tried various match/index/vlookup formulas but i cannot get it to work!
Thanks,
Bookmarks