if a cell has data then an adjancent cell equals...

[papasmurfuo9]

Hi all

i have a workbook that a user will enter into,

Column D5:D250

If D5, is greater than 1, id like

E5 to be
=VLOOKUP(D5,'Account List'!$A$1:$B$548222,2,FALSE)

F5 to be
=VLOOKUP(D5,'Account List'!$A$1:$F$548222,6,FALSE)

and L5 to be
=VLOOKUP(K5,'10-03-14'!$A$1:$BB$16028,8,FALSE)

then if D6 is greater than 1, the same to be applied but to E/F/L 6, but with the vlookup reflecting the same

and loop through up until row 250

is this possible

many thanks

[Pete_UK]

Why don't you just put this formula in E5:

=IF(D5>1,VLOOKUP(D5,'Account List'!$A$1:$B$548222,2,FALSE),"")

with similar formulae in F5 and G5, and then copy down to row 250 ?

Hope this helps.

Pete

[papasmurfuo9]

hi
Thanks for the reply

problem i have is the lookup data is 500,000 rows, so my sheet will have a button that will open the 500,000 row data, put in them formulas, get the data it needs, and then the paste values over the vlookups, if this makes sense

the file size needs to be as low as possible, when i have the lookups in the file, its over 27mb

thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[papasmurfuo9]

perfect, thank you.

[JOHN H. DAVIS]

You're welcome. Glad to help out.