Excel Function Lookup

Question

Getting a CalculatedValue from a cell with Lookup.  The value is a text value like 10-2.75 and the lookup always returns the first row from the return value column.

Prakash Kumar D · Answer

Hi Ben, 
  
Thank you for contacting Syncfusion support. 
  
We have tried in different possible scenarios to reproduce the issue, but we are unable to reproduce it. We have shared a simple sample for your reference which can be downloaded from following location. 
  
Sample link:  
http://www.syncfusion.com/downloads/support/forum/140437/ze/VLookUpSample-241524100  
 
Kindly modify the above sample to reproduce the issue and share us the modified sample along with the issue reproducing input files which will be helpful for us to give you a prompt solution at the earliest.  
  
Regards, 
Prakash Kumar

Ben · Answer

I am using Lookup not VLookup and the columns with the lookup data is in a separate sheet.  The formula looks like this: =LOOKUP(AJ2,Lookups!CX:CX,Lookups!CY:CY)

Prakash Kumar D · Answer

Hi Ben, 
 
Thank you for updating us. 
 
We have tried to reproduce the reported issue with the LookUp formula, but it works as expected. We have shared a simple sample which can be downloaded from the following link. 
 
Sample link : http://www.syncfusion.com/downloads/support/forum/140437/ze/LookUpSample-50232595   
  
We request you to modify the above sample to reproduce the issue and share us along with issue reproducing input files. It will be helpful for us to analyze further on this and provide you the solution at earliest. 
 
Regards, 
Prakash Kumar

Duncan Weishaar · Answer

The two most relevant functions when it comes to lookup are HLOOKUP and VLOOKUP. You can find a comprehensive guide to the use of these functions, complete with detailed examples, by clicking here.

There are other functions available in spreadsheet software such as EXCEL which can also do similar referencing. The following are just some of those other less well-known ways in which information can be retrieved: INDEX MATCH MATCH CONCATENATE and INDIRECT SUMPRODUCT. Information about these other methods is given through this link

HLOOKUP is the first function that people find because it's commonly used within a spreadsheet program like Microsoft EXCEL for performing lookups from left to right

Konduru Keerthi Konduru Ravichandra Raju · Answer

Hi Duncan, 
 
Thank you for your suggestion. Kindly get back to us, if you need any further assistance.  
 
Regards, 
Keerthi.

Rachel Gomez · Answer

In the Formula Bar, type =VLOOKUP().In the parentheses, enter your lookup value, followed by a comma. Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25,Enter column index number. Enter the range lookup value, either TRUE or FALSE.Regards,Rachel Gomez

Imran Khan khan · Answer

i like your post and all you share with us is uptodate and quite informative, i would like to bookmark the page so i can come here again to read you,as you have done a wonderful job.

Yaavann Vignesh Sethuraman · Answer

Hi Imran,  Please feel free to bookmark the page, and if you have any questions or need assistance, don't hesitate to reach out to us. Thank you for your patience and understanding.Regads,Yaavann.