Cell Reference / Replacement...??? HELP

[AFLeddie]

Hey there,

I have a sheet in that contains a column with tags in it (Z7580. Z7852 etc.) However, there is no description column next to the numbered column. basically I want to place a description in an Inserted column for that particular number. I have a description table on the next sheet with the description associated to the tags.

I need a formula that will do this for me, the sheet is massive. however there are only about 50 tags with their descriptions.

any help would be nice.

 

[Andrew Poulsom]

Check out the VLOOKUP function in Excel Help. Example:

=VLOOKUP(A1,Sheet2!A1:B1000,2,FALSE)

where A1 contains the tag to look up in the table in A1:B1000 on Sheet2.

 

[AFLeddie]

Thanks alot, I think I may be on to something!

 

[njimack]

Can't provide a complete formula since you haven't told us sheet names or columns. Try the following formula, replacing sheetnames as columns as required...

=VLOOKUP(Cell_containing_tag,Sheet1$!A:$B,2,FALSE)

This assumes that your list of tags and descriptions are on sheet 1, with tags in column A and descriptions in column B.