referencing current row in VLookup

i have a table of unique work orders. Each one with a different number. On Sheet 2 I have a list of work orders with quantities, but not in the same order. the formula below is returning error #N/A

=VLOOKUP("C" &ROW(),Sheet2!A:H,6,FALSE)

what am I missing?

try:
=VLOOKUP(INDIRECT("C"&ROW()),Sheet2!A:H,6,0)

Try with INDEX
=VLOOKUP(INDEX(C:C,ROW()),Sheet2!A:H,6,FALSE)

both still give the same error

okay, number was stored as text -.-

thank for your help

#N/A means no match was found in Sheet2 column A for the lookup value.
Check your data for exact match, check spelling and look for extra spaces like " hello" or "hello "

Maybe attach a sample file

You're welcome.

If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.