CODEWITHSUNDEEP
excelexcel-formula
Alan Campbell
Alan Campbell

Reputation: 417

How to inverse VLOOKUP for data entry?

My table has a date column to to the left (Column A). Other columns have share quantities and values. Using standard VLOOKUP, I can retrieve values for a given date.

However: I have new transactions, which regularly need to be added to the master table. What I need is an "inverse" function, that allows me to append (or even over-write) data to the underlying table.

So far, my searches for an "inverse" function only give me alternate ways to retrieve (with the columns out of order). Any suggestions for an appropriate method?

Upvotes: 0

Views: 280

Answers (2)

xarxziux
xarxziux

Reputation: 371

If I understand you correctly, what you are looking for is a script that can add data to the end of a table, or change data on an existing cell. Functions only work by reading data in other parts of the spreadsheet and outputting the result in the cell that they were written in. I don't think you're going to find a formula that sends data to another part of the spreadsheet.

If a script is what you're after let me know. I use scripts like that so I can code a few code snippets.

Upvotes: 1

J.B.
J.B.

Reputation: 445

Please check INDEX MATCH functions.

Upvotes: 0

Related Questions