Hi,
I have an auditing tool that I have created that calculates call rates etc, however I now have to add in a second vlookup, if that is possible.
Basically if a cell J3=1 then I need the vlookup in cell W3 to look up the first 2 columns (Names is A and Data in B), and if cell J3=2 then I need the vlookup in W3 to select data from the 3rd and 4th column, (Names in F and data in G).
the current vlookup is = VLOOKUP(N3,A1:B845,2) where N is the column that changes depending on the country etc that I select.
The names in column 1 and 3 remain constant, but a different value is present for each name depending on the supplier price. I cannot change the names to add something in, as there are over 800 entries at the moment, and this would not be practical.
please can you help?
thanks in advance.
Bookmarks