Look up table problem

Originally Posted by shannoncox

Hi everyone,

I have a very diffucult problem that I would appreciate some help with. I have a table of data... 278 rows and 5 columns. The first column is just an index column with numbers 1 to 278 populating it. The next four columns are columns that contain data. The table described above is placed in a worksheet called 'sheet2'.

Here the problem...

In a seperate worksheet, named 'sheet3' I would like a formula placed in the second, third and fourth columns so that when I placed a column of random numbers between 1 and 278 in the first column, it fetched the data corresponding to the index of the table in 'sheet2'. Does this make sense?

I have tried this formula and dragged it down and across from sheet3:B1... but it does not pick up the correct data when I place a column of random numbers in column A of 'sheet3'

=IF(ISNA(VLOOKUP(A1,Sheet2!A1:B278,2,FALSE)),"",VLOOKUP(A1,Sheet2!A1:B278,2,FALSE))

Thank you for readin this, any help would be kindly appreciated...

Shannon

Hi,

Try

=IF(ISNA(VLOOKUP(A1,Sheet2!$A$1:$B$278,2,FALSE)),"",VLOOKUP(A1,Sheet2!$A$1:$B$278,2,FALSE))


and let me know how you go.

---

Originally Posted by shannoncox

Thank you very much Bryan, it worked beautifully. That was most helpful!

Good to see, and thanks for the response.

---