Function that looks up a number and replaces it with text from a table

[Courtland Clarkson]

I have had a survey done, but the results came back to me with numbers in certain boxes instead of the text answer that was selected in the survey pick list.

Each number corresponds to an item on the pick list which I have in a separate table.

I'm hurting here, because I have to review this small sampling before the survey launches tomorrow to ,000s.

I've attached a spreadsheet:

I am trying to get the corresponding text from the table in tab 'Q3 look up' into column C in tab 'Q3'

Any help would be much appreciated.
Survey Analysis Framework - Help Please (1).xlsx

[ConneXionLost]

In cell C2 use:

Please Login or Register  to view this content.

copy down.

[Courtland Clarkson]

Wow - that's great. Thank you so much.

I'm going to need to do this a few times, would you mind helping out a little to understand what you did:

=VLOOKUP - formula prefix

VALUE(B2), - the cell to replace

'Q3 LookUp'!$A$2:$B$41 - the table with cells fixed so they won't change in the drag down

,2,0 - but don't understand this bit

[ConneXionLost]

The VALUE(B2) is what you want the formula to find in the first column of the table.

The 2 tells the formula which column of the table contains the text you want returned.

The 0 tells the formula that only an exact value match will do (not the next closest).

[Courtland Clarkson]

Makes sense now - thanks so much.