Urgent help..nested functions..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I am Siddharth,
I have a 2 column database in Sheet2 of a workbook file.
I have a 15 digit number say 550660506050504
I extracted 4 numbers from the above specified number say 6605.
now problem is that I have to search this number from the database(Sheet2)
which is definitely there. I have used vlookup, Hlookup which have generated
the corrrect result, but only when i manually enter this number in a cell
with out any formula in the cell.
Problem statement is hlookup & vlookup is not producing a result when I am
referencing this cell which has a formula MID to extract 4 numbers from the
15 digit number.
i hope you understand my problem.
Kindly help asap.
(e-mail address removed)

Thanks & regards.
 
Why not just insert an extra column containing your extraction data and then
look that up.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

looking up data/numbers in table 2
Please help with a formula 6
VLOOKUP, VCONFUSED 2
Nested hlookup/vlookup (possibly just an if statement though?!?) 1
VBA ln function 2
Hlookup-Drag to rows below 5
Need Help with VLOOKUP 4
Excel Vlookup Help 0

Back
Top