Using number in one sheet to draw content from another sheet

I've tried using the search facility for this but it doesn't seem to be playing ball today.

I have a column of numbers in one sheet and in the second sheet there are two columns, column a is the corresponding number from the first sheet and column b is the wording for that number. See example below.
What formula could I use to draw the data from one to sheet to another to make the words replace the numbers in the column of the other sheet?

Sheet
102
107
119
145

Sheet 1
Column A Column B
102 Apples
107 Oranges
119 Pears
145 Grapes

Many thanks
Mike

You can't replace the numbers with formulas, but you can a formula next to the number...

e.g. in column B, =Lookup(A1,Sheet2!A:B) which assumes column 1 in sheet 2 is in ascending order...

As this is the excel programming forum this might be a solution

Please Login or Register  to view this content.

Then maybe

=Vlookup(A1,Sheet2!A:B,2,FALSE)

In which cell do I add the above into?
Have tried it in B1 on sheet 1 and it doesn't like it

The wording on sheet2 is in column b for the numbers on sheet1
Sheet2 is a reference for the values in sheet1 and is numbered in numerical value on sheet2 in column a

Originally Posted by mike_m1

One final thing, how do I delete the cells which don't contain any information so therefore just give an error ' #N/A ' ?

Do you mean?

=IF(ISNA(Vlookup(A1,Sheet2!A:B,2,FALSE)),"",Vlookup(A1,Sheet2!A:B,2,FALSE))

This returns you a blank if the item was not found.