Vlookup Function

I think, all i need is a match in any of the cells, either A1,B1,C1 etc.


So, if there is a match in A1, then it would populate the relevant
values on sht2. If A1 does not match, then it should check B1, if B1
does not match then it should check C1 etc.

Thanks

Spike


---
Message posted from http://www.ExcelForum.com/

Hi Spike

in that case i would say the easiest way to achieve what you want is to
insert a column in both sheet 1 & 2 (column D) and type for both
=IF(A1="",IF(B1="",C1,B1),A1)
and fill down for all rows

then on sheet 2 for column E
type
=IF(VLOOKUP($D1,Sheet1!$D$1:$I$4,2,FALSE)=0,"",VLO OKUP($D1,Sheet1!$D$1:$I$4,
2,FALSE))
copy across to rows F, G, H, I
changing the ,2, to ,3, for column F; ,4, for column G; ,5, for column H &
,6, for column I (ie the third parameter)
in both VLOOKUP statements
and then fill down all rows

i'm not sure it will work for all combinations and variations possible but
might get you somewhere -hopefully someone else will have a more generic
solution if required.

Cheers
JulieD


"=BA=Spike " wrote in message
...
I think, all i need is a match in any of the cells, either A1,B1,C1 etc.


So, if there is a match in A1, then it would populate the relevant
values on sht2. If A1 does not match, then it should check B1, if B1
does not match then it should check C1 etc.

Thanks

Spike


---
Message posted from http://www.ExcelForum.com/