Using reference data from one table to populate another column/table

[thirdeye85]

Hi there,

I am curious as to what would be the preferred method to populate data that I would consider reference data from one column (or multiple, perhaps a table even) into another table with again, multiple columns.

For example, this would be used for double entry booking insofar as I am accounting for let's say lettuce [column A],with an account debited [column B], and an accounted credited [column C].

[column A] [column B] [column C]
ITEM Account Debited Account Credited
lettuce Food account Credit Card Account

Currently, I have to input data manually for all of column A, B, and C. If I would be able to make a table that has "reference values" for "lettuce", ie, when lettuce is entered into column A, [column B] should populate with "Food account" and [column C] with "Credit Card Account".

I am familiar with the nested IF functions, however, I would like to avoid a gigantic formula and would rather create a hidden table of sorts where I can quickly update these values without constantly changing the formula.

Any point in the right direction would be appreciated!

 

[RobP]

Hi,

theres probably lots of different ways to do things here, but one suggestion would be to use a "VLOOKUP()" ? VLOOKUP Function

It does need your data to be in the right columns, but I think from what you describe it could do the job for you.

Cheers
Rob

 

[thirdeye85]

Thank you I will check it out!