View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Lookup Function Not in Ascending Order

Glad to be of help - thanks for feeding back.

Pete

On Jul 29, 12:25*pm, Jessica Donadio
wrote:
thank you so much for your quick response! *Your post help me clear up my
uncertainty with the previous posts I read in regards to VLookup, I didn't
understand the 3rd parameter indicated the 1st, 2nd, 3rd, column, and that
the table was an area you could select. *Adding the logic test was just what
I needed to do. *