Vlookup

[Cheril Ann]

Hi good night,

I am trying to get a text return in my workbook.

I have sales order workbook week 2 with a number in column A and remarks (text) in column B. I pulled a fresh update and of the sales order week 3 and would like to have the remarks from last week be looked up in week 2 to week three. But its a text result and i get N/A.

Any assistance will be great.

Thanks
Cheril-Ann

 

[mrshl9898]

What formula are you using, and what are the values in the cells?

 

[Cheril Ann]

I tried the istext with vlookup formula and the regular vlookup which returns NA. In the cells are text.

Thanks

 

[TimNevins]

Unless I'm missing the point, you can try this:

=vlookup(MyOrderNo,MyOrderCommentRange,2.0)

This assumes that your data is in a vertical table, order numbers is column A, comments in column B. You are matching the order number to contents of column A to return the contents of column B in MyOrderCommentRange. Your range has to include both columns (say, A1:B200). This also assumes that the order numbers are unique and don't occur multiple times in column A.

If that works, you can wrap it in IfError to supress N/As when the order number isn't found in the previous week. Also, mind your ranges, you'll want to make them absolute references or defined names.

 

[Cheril Ann]

Thank you, I am going to try it and see if it works.