HI GUYS and GALS is it poassable to add a column to a exsting table based on another table using a if statement i.e Table one RefStatusblahblah blah1A152A153R25 Table 2 RefStataus Nostatusnotes11Raisedblah blah blah 12Dispatched blah blah blah 13Diliveredblah blah blah 21Raisedblah blah blah 22Dispatched blah blah blah 399Out of stockblah blah blah Combined table i only want notes when theres a problem (status 99) other wise blank RefStatusblahblah blahnotes1G15 2A15 39925blah blah blah

Sir_night, Simply try LOOKUPVALUE Function. notes = LOOKUPVALUE ( Table2[notes], Table2[Ref], Table1[Ref], Table2[Stataus No], 99 )

Forum Discussion

Frequent Visitor

9 years ago

Solved

HI GUYS and GALS

is it poassable to add a column to a exsting table based on another table using a if statement

i.e

Table one

Table 2

Combined table

i only want notes when theres a problem (status 99) other wise blank