Forum Discussion

Rory Nall's avatar
Rory Nall
Copper Contributor
Jan 05, 2018

Using vlookup to affect an entire column

I have two workbooks. WB1 has account information and point balances. WB2 has account information and color fills that I've got to keep (why I can't just use WB1). I need to get the point balances into WB2, but I can't figure out how to set up vlookup to do that for an entire column. I do not have time to go row by row as I have over 28k. How can I do this?

Formulas & Functions
Requests

4 Replies

  • Sage9 Lim's avatar
    Sage9 Lim
    Copper Contributor
    Jan 05, 2018

    if you can fill 1 cell w/ vlookup, flashfill the rest in column w/ 1 click.

    • Rory Nall's avatar
      Rory Nall
      Copper Contributor
      Jan 05, 2018

      I tried that, but everything is all 0s and N/As.

      • Sage9 Lim's avatar
        Sage9 Lim
        Copper Contributor
        Jan 05, 2018

        seem like data: accountInfo could be different "type" in WB1 and WB2. 

        Normally it looks nicer to do "ifna(vlookup(...),"")

         

        another place you can check is the vlookup, make sure the $ there

Resources