Provide a match from 2 cells to give a result from another
Thats fab many thanks, I need the user to be able to add many rows all with
the same formulars but differant products an modes, When i copy the formular
I have to change the "lookup Range" Is their a quick way to do this or do I
have to chage each row individulay?
Many Thanks
Scoops wrote:
Hi I hope you can help with this is should be simple but I can not get it to
work.
[quoted text clipped - 42 lines]
Lee
Hi Lee
On sheet 2, put the values from columns A and B in column A (i.e.A2 is
"RobeMode1").
Delete column B.
In sheet 1, cell C2 enter
=if(or(A2="",B2=""),"",Vlookup(A2&B2,Sheet2!A2:B1 0,2,FALSE))
Adjust the lookup range (Sheet2!A2:B10) as required.
Regards
Steve
|