Reverse of Hlook up

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

Guest

As we have hlookup formula in Excel where we get the information at a particular row with the first column number given by the used So we can basically pull the data .Do we have any formula in Excel where I can insert data at a particular location based on the first column match.Put the data a particular location
 
Jens

If I understand you correctly, you cannot enter data into another cell with
a Function. It can only return a value to the cell in which the function
is.

You may need some VBA code to achieve what you are doing. If I have
misunderstood, please post back

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)


Jens said:
As we have hlookup formula in Excel where we get the information at a
Click to expand...
particular row with the first column number given by the used So we can
basically pull the data .Do we have any formula in Excel where I can insert
data at a particular location based on the first column match.Put the data a
particular location
 
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

Best way to get data from Access 2003 to Excel 2003 6
Moving from Excel to Visual Studio 3
Mid column sum formulas with varied ranges to sum 17
Find last column & copy/paste values 1
Changes in How Code Acts After Upgrade of Excel 2
Pulling data from one workbook to another one using VBA 0
Can I have default data in new rows? 1
Summarize information on different sheets of the workbook 1

Back
Top